UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05o6oqnjb5crhom5LC4CX5tHkl6MTpaac7mhZHf1L0o='
WHERE
key_id = 'aef2fcdb335e1bb5540dfd119e1dd74907c1e97700053833cbc6ee75920b42bb'
AND (
token = '05o6oqnjb5crhom5LC4CX5tHkl6MTpaac7mhZHf1L0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)