UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hs4wQKflRFhaL2uuJPU4FtvXIHzx6tHjRklzCimgXyg='
WHERE
key_id = '7a3f30d405ea8f564a987fbfb4ad05774c34845b656563d9b468117055e3b345'
AND (
token = 'hs4wQKflRFhaL2uuJPU4FtvXIHzx6tHjRklzCimgXyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)