UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UpnySf6pcVR6nYJwoYVpsA0bTOvc+p0aNeD0Y95JLBE='
WHERE
key_id = 'dfeda176f52b04b14b395c3f241cd7fb16a543d315135dc31fbb59bdfcef18fb'
AND (
token = 'UpnySf6pcVR6nYJwoYVpsA0bTOvc+p0aNeD0Y95JLBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)