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