UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GZA+X9N0cFT0lyRZMwf/Q6sTm/sZeBJIgTRfXO3e+X8='
WHERE
key_id = 'd46c11d93b71af9335daa49e297f3b5acca2d1346a66c4a01f16864f04c3ede4'
AND (
token = 'GZA+X9N0cFT0lyRZMwf/Q6sTm/sZeBJIgTRfXO3e+X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)