UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5Zw4mySTZe62A3+qYm2YSRTIOn8DcQhj7wO/M157mU='
WHERE
key_id = '6a3d7a6cc0b099f965ff27cbcdb1a8b95f6d8e6ea6fb93ee3d7d370339f47b8f'
AND (
token = 'k5Zw4mySTZe62A3+qYm2YSRTIOn8DcQhj7wO/M157mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)