UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gen9qlnY1MPEAlkgp19W20em3adOIDSBjh2gH43uFCM='
WHERE
key_id = 'cbf1c095021579e9b75ad721f4635588bfa38e011190f100a00b228ca4a788dc'
AND (
token = 'Gen9qlnY1MPEAlkgp19W20em3adOIDSBjh2gH43uFCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)