UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r14/XgMpzJ1BfURaDemnp8DZxEh8pn0T47BpAxOxRYg='
WHERE
key_id = '7a1d1e2d31f8c9c0f4b8daef47f76e9872c2a77a6a6ece35def44757d281e34f'
AND (
token = 'r14/XgMpzJ1BfURaDemnp8DZxEh8pn0T47BpAxOxRYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)