UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yRjEsJ2fa9ILecZp+QSqHH/mw/EaBXjLUwKcia9Idsw='
WHERE
key_id = 'e78fcba42109e4cefde412b7bf3c1b79b596de50cb43731662f8edc718a47733'
AND (
token = 'yRjEsJ2fa9ILecZp+QSqHH/mw/EaBXjLUwKcia9Idsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)