UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+IZ9wU02rPi1Xy0zstCUmemSlOtUY8zYaYfcA8lH9LI='
WHERE
key_id = '14fa83af832767f8c76ee33251aa57da13b3489347454b5bbdeb86186638ba8a'
AND (
token = '+IZ9wU02rPi1Xy0zstCUmemSlOtUY8zYaYfcA8lH9LI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)