UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CfcaLcUWEMg8fA3e4e1U21MgCBrJGc00yciyZR/cagk='
WHERE
key_id = 'f11cee2994b1063d977ade1e302a298a092fb2277c935844f71b6e1c5adf8fce'
AND (
token = 'CfcaLcUWEMg8fA3e4e1U21MgCBrJGc00yciyZR/cagk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)