UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7iqiXxyWU9pw/HnQTKxuXGZ9Qm9mRlmIdcdLNWVOCk='
WHERE
key_id = '39f264e69ab515463ca7645d7998bda2e142babff256f4ab0137f3520d567ae0'
AND (
token = 'C7iqiXxyWU9pw/HnQTKxuXGZ9Qm9mRlmIdcdLNWVOCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)