UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmZDfK2WL2GDex24MJ7J5vaC/rRbs8y+mSs8uCskLlE='
WHERE
key_id = '506f1b1bee75218c06e7f22051afd57f6fb94609265f0d01e73d8298b7083b8b'
AND (
token = 'pmZDfK2WL2GDex24MJ7J5vaC/rRbs8y+mSs8uCskLlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)