UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ThlIYsU6wAZ9MHLGfhhtDhfiYgtaDerWLT4G0jWqRo='
WHERE
key_id = '5316d7af802abffed3814700f52b89a6009478c4db8e2edb80ba53dcccad676b'
AND (
token = '1ThlIYsU6wAZ9MHLGfhhtDhfiYgtaDerWLT4G0jWqRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)