UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKiRKqeft0Nc9DNBZHIjbROok/bZH01X63DRQZRDzyI='
WHERE
key_id = 'a7d9aa11cdc186b85af1ba720ef424fdccb5ea72cb7a4c3d24d3c06f3aaa29c5'
AND (
token = 'LKiRKqeft0Nc9DNBZHIjbROok/bZH01X63DRQZRDzyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)