UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xigDjemNta1DnR69lTIMKvPKGxANiCwcIZaoXnkH7i8='
WHERE
key_id = '44237956a8accff2d3f60f1e2b73c2db4245e1e2e62081e60c616e565644f96a'
AND (
token = 'xigDjemNta1DnR69lTIMKvPKGxANiCwcIZaoXnkH7i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)