UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2opMq3LEqRtOYc+MvOC0fHWuy+XOJ5bGjS93wlAl10='
WHERE
key_id = 'c813f3ae2d4b3b9ae5fd8b15919f6b3f19edf6f4551f9fed5501c376f0a8d3f3'
AND (
token = 'x2opMq3LEqRtOYc+MvOC0fHWuy+XOJ5bGjS93wlAl10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)