UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lj0PYHh0K7icwffhKgFRtDoHDles65uEwUiQfElZedA='
WHERE
key_id = 'd3cf7a21e30796021ae0cccae38eeb1df2cc78b8c815e029f2ce8276481b74df'
AND (
token = 'Lj0PYHh0K7icwffhKgFRtDoHDles65uEwUiQfElZedA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)