UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhIc8ioe3npa+c/w5YGin5N3mn8bydg3BLxWd4o5P+I='
WHERE
key_id = 'c4de67491f9e594e4315759b0a8bf9320ec643bafab4e6bfa1b320d6f65d3cab'
AND (
token = 'XhIc8ioe3npa+c/w5YGin5N3mn8bydg3BLxWd4o5P+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)