UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oxJZCa3oZ0yhQ0T7PYVnUHI5fx04JUAIB44t4ytRyQ='
WHERE
key_id = '9e3eed8a321420740ec308fcac3feaa9bda5040d83c0b5a43671ea8ad192f24e'
AND (
token = '2oxJZCa3oZ0yhQ0T7PYVnUHI5fx04JUAIB44t4ytRyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)