UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/r7hRUaA4jdcz3deMt1wss131M+5nkwuU824pM78UrM='
WHERE
key_id = '3f4bf3c9700770f68018b8dd5df326a51b0f2b704e46edbbd1bf79c74fe60ee3'
AND (
token = '/r7hRUaA4jdcz3deMt1wss131M+5nkwuU824pM78UrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)