UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PQvdtnZNoe4odqIaJN0moEkoFQxk8h6F3WaUPumaniM='
WHERE
key_id = '165ec3002a0f980a2111ad57bf8ab51db485905d08e2cad881e815bdf3174faf'
AND (
token = 'PQvdtnZNoe4odqIaJN0moEkoFQxk8h6F3WaUPumaniM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)