UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHfdgfU6NnJCPyQpmvi6kQ08zbJnZWCZt7myQ9imOrY='
WHERE
key_id = '9a6ef856657f6f9dd258db59f3c3ae235f56f131b17504862d5757ddf320fa43'
AND (
token = 'nHfdgfU6NnJCPyQpmvi6kQ08zbJnZWCZt7myQ9imOrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)