UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtYFVZYrTKYJQsNnga104dm92zwGbnfeLvTGstjiueI='
WHERE
key_id = 'c374d6f5e0cfaf5688c532786fc0589cd926839e9306f4bf93ad03244263fba2'
AND (
token = 'xtYFVZYrTKYJQsNnga104dm92zwGbnfeLvTGstjiueI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)