UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXZ7fi8mLBVo520GCOzuiaSl6iC3ekRugUMuwYsitRo='
WHERE
key_id = '3ad0b4468555b7bc98461aee3b5bcbb340ccf0d21b8a07285536b23f490799d0'
AND (
token = 'tXZ7fi8mLBVo520GCOzuiaSl6iC3ekRugUMuwYsitRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)