UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rV5ACaSOH2X5gS3KB57GO+ShBDiSD5yEEn4Svije+wM='
WHERE
key_id = '4a9b0eaf83ecbd01a29602fa9029a56f473c8147ba551183263c8cb349851e59'
AND (
token = 'rV5ACaSOH2X5gS3KB57GO+ShBDiSD5yEEn4Svije+wM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)