UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a+KnMLxqrHlqtgIAW/9z7DXBbiezHo0WiIOJP/FghsY='
WHERE
key_id = 'c06c088a37d0385be5a24d7788dd7f884c0acbd6ad6ecef943bd09f6dfc1f1d8'
AND (
token = 'a+KnMLxqrHlqtgIAW/9z7DXBbiezHo0WiIOJP/FghsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)