UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pliyFs+XFUpgBhbu/Oot3X0cPfFKWc6e28+d6iCH9Qk='
WHERE
key_id = 'b564bc0bbbcda6c762c3662b1a4a8531cdd9790eee59b4085205fcb1bd849688'
AND (
token = 'pliyFs+XFUpgBhbu/Oot3X0cPfFKWc6e28+d6iCH9Qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)