UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXSI9l49rKlVh0myrD/70s7tcQdiDqKEwMmMAUz+V6A='
WHERE
key_id = 'e12ba8c02b84b8a95e0ed5cb843b7d1e8918d8d1b96e2547ca6e79453eb0b997'
AND (
token = 'DXSI9l49rKlVh0myrD/70s7tcQdiDqKEwMmMAUz+V6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)