UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOD6+hWG/pRGFHv57lceqf784QSVW+6vwOH3TX8cTPw='
WHERE
key_id = '6f5948c8b3ca0a7aee7292e4c611cf8c5c5818556e9df8940263fcc24139c40d'
AND (
token = 'HOD6+hWG/pRGFHv57lceqf784QSVW+6vwOH3TX8cTPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)