UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HW4UT1kF+zsu2seooMnoV32L2v8bP6GXX1JK49EtMOM='
WHERE
key_id = 'e082090945914a4d2c41692dc585e27e3242cac2dd101357fa68b60cd63116ae'
AND (
token = 'HW4UT1kF+zsu2seooMnoV32L2v8bP6GXX1JK49EtMOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)