UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/nlSc2NFDdBzvhGI2THvHbIu5cY+aVBMecCGeRkzj3M='
WHERE
key_id = '4d89a5af096cf5046a50ac9e8d34d40214ffd0a4c826dadabbefdfb02a8c497e'
AND (
token = '/nlSc2NFDdBzvhGI2THvHbIu5cY+aVBMecCGeRkzj3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)