UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WvAcwqt3HKWbqJDm4/JV9fIhI+7gvPXWQ7IMoxggZKI='
WHERE
key_id = 'ed4e60e6b595219c31aee3a228df968ca63247646fd0f824116a0df779afdc99'
AND (
token = 'WvAcwqt3HKWbqJDm4/JV9fIhI+7gvPXWQ7IMoxggZKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)