UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UdcD5FnGs3R6vKeZu47FcbJoOydHm1OzpHPWOn/U60='
WHERE
key_id = '6ca7e690867b5e5ee47167890774767be2b9164b368781c326e87a1d13cb4931'
AND (
token = '9UdcD5FnGs3R6vKeZu47FcbJoOydHm1OzpHPWOn/U60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)