UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V6KA56w4FVi5VEa4qvf/NrMVb+d0+XnxkRmqFkiDW9s='
WHERE
key_id = '29499287f9dd03f916f8da827a267bece806e82811114665e5b9b4834fb391c0'
AND (
token = 'V6KA56w4FVi5VEa4qvf/NrMVb+d0+XnxkRmqFkiDW9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)