UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ooqm6bim94w427tGn412jrDQ+BU6grSQ39QFA+mcCj0='
WHERE
key_id = 'bd022fe2eee1845c10cdbe7bb01e2f4b34dac0948306317e3a1fb5457468f407'
AND (
token = 'Ooqm6bim94w427tGn412jrDQ+BU6grSQ39QFA+mcCj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)